package com.extweb4j.core.model;

import java.util.List;

/**
 * 
 * @author Administrator
 *
 */
public class ExtJobUser extends CoreModel<ExtJobUser>{

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	public static ExtJobUser dao = new ExtJobUser();
	
	public List<ExtUser> findUserByJobId(String job_id){
		StringBuffer buffer = new StringBuffer();
		buffer.append(" SELECT * FROM ext_user u");
		buffer.append(" LEFT JOIN  ext_job_user j ON j.user_id = u.id ");
		buffer.append(" WHERE j.job_id=?");
		return ExtUser.dao.find(buffer.toString(),job_id);
	}

}
